/*
*
* ByProductPriceBeanExample.java
* @author 18304
* @date 2020-11-18 11:07:46
*/
package com.steel.yfmall.cloud.assistant.po.view;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ByProductPriceBeanExample {
    /**
     * zg_by_product_price
     */
    protected String orderByClause;

    /**
     * zg_by_product_price
     */
    protected boolean distinct;

    /**
     * zg_by_product_price
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:zg_by_product_price
     * @Title: ByProductPriceBeanExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public ByProductPriceBeanExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:zg_by_product_price
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:zg_by_product_price
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2020-11-18 11:07:46
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:zg_by_product_price
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:zg_by_product_price
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2020-11-18 11:07:46
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:zg_by_product_price
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2020-11-18 11:07:46
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:zg_by_product_price
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:zg_by_product_price
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2020-11-18 11:07:46
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:zg_by_product_price
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2020-11-18 11:07:46
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:zg_by_product_price
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2020-11-18 11:07:46
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:zg_by_product_price
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2020-11-18 11:07:46
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title zg_by_product_price表的实体类
     * @description zg_by_product_price
     * @version 1.0
     * @author 18304
     * @date 2020-11-18 11:07:46
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCompIdIsNull() {
            addCriterion("comp_id is null");
            return (Criteria) this;
        }

        public Criteria andCompIdIsNotNull() {
            addCriterion("comp_id is not null");
            return (Criteria) this;
        }

        public Criteria andCompIdEqualTo(String value) {
            addCriterion("comp_id =", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdNotEqualTo(String value) {
            addCriterion("comp_id <>", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdGreaterThan(String value) {
            addCriterion("comp_id >", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdGreaterThanOrEqualTo(String value) {
            addCriterion("comp_id >=", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdLessThan(String value) {
            addCriterion("comp_id <", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdLessThanOrEqualTo(String value) {
            addCriterion("comp_id <=", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdLike(String value) {
            addCriterion("comp_id like", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdNotLike(String value) {
            addCriterion("comp_id not like", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdIn(List<String> values) {
            addCriterion("comp_id in", values, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdNotIn(List<String> values) {
            addCriterion("comp_id not in", values, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdBetween(String value1, String value2) {
            addCriterion("comp_id between", value1, value2, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdNotBetween(String value1, String value2) {
            addCriterion("comp_id not between", value1, value2, "compId");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoIsNull() {
            addCriterion("by_prod_price_no is null");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoIsNotNull() {
            addCriterion("by_prod_price_no is not null");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoEqualTo(String value) {
            addCriterion("by_prod_price_no =", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoNotEqualTo(String value) {
            addCriterion("by_prod_price_no <>", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoGreaterThan(String value) {
            addCriterion("by_prod_price_no >", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoGreaterThanOrEqualTo(String value) {
            addCriterion("by_prod_price_no >=", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoLessThan(String value) {
            addCriterion("by_prod_price_no <", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoLessThanOrEqualTo(String value) {
            addCriterion("by_prod_price_no <=", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoLike(String value) {
            addCriterion("by_prod_price_no like", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoNotLike(String value) {
            addCriterion("by_prod_price_no not like", value, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoIn(List<String> values) {
            addCriterion("by_prod_price_no in", values, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoNotIn(List<String> values) {
            addCriterion("by_prod_price_no not in", values, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoBetween(String value1, String value2) {
            addCriterion("by_prod_price_no between", value1, value2, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andByProdPriceNoNotBetween(String value1, String value2) {
            addCriterion("by_prod_price_no not between", value1, value2, "byProdPriceNo");
            return (Criteria) this;
        }

        public Criteria andPriceDatesIsNull() {
            addCriterion("price_dates is null");
            return (Criteria) this;
        }

        public Criteria andPriceDatesIsNotNull() {
            addCriterion("price_dates is not null");
            return (Criteria) this;
        }

        public Criteria andPriceDatesEqualTo(Date value) {
            addCriterion("price_dates =", value, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesNotEqualTo(Date value) {
            addCriterion("price_dates <>", value, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesGreaterThan(Date value) {
            addCriterion("price_dates >", value, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesGreaterThanOrEqualTo(Date value) {
            addCriterion("price_dates >=", value, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesLessThan(Date value) {
            addCriterion("price_dates <", value, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesLessThanOrEqualTo(Date value) {
            addCriterion("price_dates <=", value, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesIn(List<Date> values) {
            addCriterion("price_dates in", values, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesNotIn(List<Date> values) {
            addCriterion("price_dates not in", values, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesBetween(Date value1, Date value2) {
            addCriterion("price_dates between", value1, value2, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatesNotBetween(Date value1, Date value2) {
            addCriterion("price_dates not between", value1, value2, "priceDates");
            return (Criteria) this;
        }

        public Criteria andPriceDatefIsNull() {
            addCriterion("price_datef is null");
            return (Criteria) this;
        }

        public Criteria andPriceDatefIsNotNull() {
            addCriterion("price_datef is not null");
            return (Criteria) this;
        }

        public Criteria andPriceDatefEqualTo(Date value) {
            addCriterion("price_datef =", value, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefNotEqualTo(Date value) {
            addCriterion("price_datef <>", value, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefGreaterThan(Date value) {
            addCriterion("price_datef >", value, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefGreaterThanOrEqualTo(Date value) {
            addCriterion("price_datef >=", value, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefLessThan(Date value) {
            addCriterion("price_datef <", value, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefLessThanOrEqualTo(Date value) {
            addCriterion("price_datef <=", value, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefIn(List<Date> values) {
            addCriterion("price_datef in", values, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefNotIn(List<Date> values) {
            addCriterion("price_datef not in", values, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefBetween(Date value1, Date value2) {
            addCriterion("price_datef between", value1, value2, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andPriceDatefNotBetween(Date value1, Date value2) {
            addCriterion("price_datef not between", value1, value2, "priceDatef");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNull() {
            addCriterion("cust_no is null");
            return (Criteria) this;
        }

        public Criteria andCustNoIsNotNull() {
            addCriterion("cust_no is not null");
            return (Criteria) this;
        }

        public Criteria andCustNoEqualTo(String value) {
            addCriterion("cust_no =", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotEqualTo(String value) {
            addCriterion("cust_no <>", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThan(String value) {
            addCriterion("cust_no >", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoGreaterThanOrEqualTo(String value) {
            addCriterion("cust_no >=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThan(String value) {
            addCriterion("cust_no <", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLessThanOrEqualTo(String value) {
            addCriterion("cust_no <=", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoLike(String value) {
            addCriterion("cust_no like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotLike(String value) {
            addCriterion("cust_no not like", value, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoIn(List<String> values) {
            addCriterion("cust_no in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotIn(List<String> values) {
            addCriterion("cust_no not in", values, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoBetween(String value1, String value2) {
            addCriterion("cust_no between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andCustNoNotBetween(String value1, String value2) {
            addCriterion("cust_no not between", value1, value2, "custNo");
            return (Criteria) this;
        }

        public Criteria andProdTypeIsNull() {
            addCriterion("prod_type is null");
            return (Criteria) this;
        }

        public Criteria andProdTypeIsNotNull() {
            addCriterion("prod_type is not null");
            return (Criteria) this;
        }

        public Criteria andProdTypeEqualTo(String value) {
            addCriterion("prod_type =", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeNotEqualTo(String value) {
            addCriterion("prod_type <>", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeGreaterThan(String value) {
            addCriterion("prod_type >", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeGreaterThanOrEqualTo(String value) {
            addCriterion("prod_type >=", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeLessThan(String value) {
            addCriterion("prod_type <", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeLessThanOrEqualTo(String value) {
            addCriterion("prod_type <=", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeLike(String value) {
            addCriterion("prod_type like", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeNotLike(String value) {
            addCriterion("prod_type not like", value, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeIn(List<String> values) {
            addCriterion("prod_type in", values, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeNotIn(List<String> values) {
            addCriterion("prod_type not in", values, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeBetween(String value1, String value2) {
            addCriterion("prod_type between", value1, value2, "prodType");
            return (Criteria) this;
        }

        public Criteria andProdTypeNotBetween(String value1, String value2) {
            addCriterion("prod_type not between", value1, value2, "prodType");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoIsNull() {
            addCriterion("create_emp_no is null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoIsNotNull() {
            addCriterion("create_emp_no is not null");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoEqualTo(String value) {
            addCriterion("create_emp_no =", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoNotEqualTo(String value) {
            addCriterion("create_emp_no <>", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoGreaterThan(String value) {
            addCriterion("create_emp_no >", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoGreaterThanOrEqualTo(String value) {
            addCriterion("create_emp_no >=", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoLessThan(String value) {
            addCriterion("create_emp_no <", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoLessThanOrEqualTo(String value) {
            addCriterion("create_emp_no <=", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoLike(String value) {
            addCriterion("create_emp_no like", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoNotLike(String value) {
            addCriterion("create_emp_no not like", value, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoIn(List<String> values) {
            addCriterion("create_emp_no in", values, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoNotIn(List<String> values) {
            addCriterion("create_emp_no not in", values, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoBetween(String value1, String value2) {
            addCriterion("create_emp_no between", value1, value2, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateEmpNoNotBetween(String value1, String value2) {
            addCriterion("create_emp_no not between", value1, value2, "createEmpNo");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("create_date is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("create_date is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("create_date =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("create_date <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("create_date >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("create_date >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("create_date <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("create_date <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("create_date in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("create_date not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("create_date between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("create_date not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoIsNull() {
            addCriterion("update_emp_no is null");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoIsNotNull() {
            addCriterion("update_emp_no is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoEqualTo(String value) {
            addCriterion("update_emp_no =", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotEqualTo(String value) {
            addCriterion("update_emp_no <>", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoGreaterThan(String value) {
            addCriterion("update_emp_no >", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoGreaterThanOrEqualTo(String value) {
            addCriterion("update_emp_no >=", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoLessThan(String value) {
            addCriterion("update_emp_no <", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoLessThanOrEqualTo(String value) {
            addCriterion("update_emp_no <=", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoLike(String value) {
            addCriterion("update_emp_no like", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotLike(String value) {
            addCriterion("update_emp_no not like", value, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoIn(List<String> values) {
            addCriterion("update_emp_no in", values, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotIn(List<String> values) {
            addCriterion("update_emp_no not in", values, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoBetween(String value1, String value2) {
            addCriterion("update_emp_no between", value1, value2, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateEmpNoNotBetween(String value1, String value2) {
            addCriterion("update_emp_no not between", value1, value2, "updateEmpNo");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("update_date is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("update_date is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("update_date =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("update_date <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("update_date >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("update_date >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("update_date <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("update_date <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("update_date in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("update_date not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("update_date between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("update_date not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andContyIsNull() {
            addCriterion("conty is null");
            return (Criteria) this;
        }

        public Criteria andContyIsNotNull() {
            addCriterion("conty is not null");
            return (Criteria) this;
        }

        public Criteria andContyEqualTo(String value) {
            addCriterion("conty =", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyNotEqualTo(String value) {
            addCriterion("conty <>", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyGreaterThan(String value) {
            addCriterion("conty >", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyGreaterThanOrEqualTo(String value) {
            addCriterion("conty >=", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyLessThan(String value) {
            addCriterion("conty <", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyLessThanOrEqualTo(String value) {
            addCriterion("conty <=", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyLike(String value) {
            addCriterion("conty like", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyNotLike(String value) {
            addCriterion("conty not like", value, "conty");
            return (Criteria) this;
        }

        public Criteria andContyIn(List<String> values) {
            addCriterion("conty in", values, "conty");
            return (Criteria) this;
        }

        public Criteria andContyNotIn(List<String> values) {
            addCriterion("conty not in", values, "conty");
            return (Criteria) this;
        }

        public Criteria andContyBetween(String value1, String value2) {
            addCriterion("conty between", value1, value2, "conty");
            return (Criteria) this;
        }

        public Criteria andContyNotBetween(String value1, String value2) {
            addCriterion("conty not between", value1, value2, "conty");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeIsNull() {
            addCriterion("date_create_time is null");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeIsNotNull() {
            addCriterion("date_create_time is not null");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeEqualTo(Date value) {
            addCriterion("date_create_time =", value, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeNotEqualTo(Date value) {
            addCriterion("date_create_time <>", value, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeGreaterThan(Date value) {
            addCriterion("date_create_time >", value, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("date_create_time >=", value, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeLessThan(Date value) {
            addCriterion("date_create_time <", value, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("date_create_time <=", value, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeIn(List<Date> values) {
            addCriterion("date_create_time in", values, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeNotIn(List<Date> values) {
            addCriterion("date_create_time not in", values, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeBetween(Date value1, Date value2) {
            addCriterion("date_create_time between", value1, value2, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andDateCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("date_create_time not between", value1, value2, "dateCreateTime");
            return (Criteria) this;
        }

        public Criteria andVersionIntIsNull() {
            addCriterion("version_int is null");
            return (Criteria) this;
        }

        public Criteria andVersionIntIsNotNull() {
            addCriterion("version_int is not null");
            return (Criteria) this;
        }

        public Criteria andVersionIntEqualTo(Integer value) {
            addCriterion("version_int =", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotEqualTo(Integer value) {
            addCriterion("version_int <>", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntGreaterThan(Integer value) {
            addCriterion("version_int >", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntGreaterThanOrEqualTo(Integer value) {
            addCriterion("version_int >=", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntLessThan(Integer value) {
            addCriterion("version_int <", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntLessThanOrEqualTo(Integer value) {
            addCriterion("version_int <=", value, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntIn(List<Integer> values) {
            addCriterion("version_int in", values, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotIn(List<Integer> values) {
            addCriterion("version_int not in", values, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntBetween(Integer value1, Integer value2) {
            addCriterion("version_int between", value1, value2, "versionInt");
            return (Criteria) this;
        }

        public Criteria andVersionIntNotBetween(Integer value1, Integer value2) {
            addCriterion("version_int not between", value1, value2, "versionInt");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeIsNull() {
            addCriterion("date_update_time is null");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeIsNotNull() {
            addCriterion("date_update_time is not null");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeEqualTo(Date value) {
            addCriterion("date_update_time =", value, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeNotEqualTo(Date value) {
            addCriterion("date_update_time <>", value, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeGreaterThan(Date value) {
            addCriterion("date_update_time >", value, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("date_update_time >=", value, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeLessThan(Date value) {
            addCriterion("date_update_time <", value, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("date_update_time <=", value, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeIn(List<Date> values) {
            addCriterion("date_update_time in", values, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeNotIn(List<Date> values) {
            addCriterion("date_update_time not in", values, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("date_update_time between", value1, value2, "dateUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDateUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("date_update_time not between", value1, value2, "dateUpdateTime");
            return (Criteria) this;
        }
    }

    /**
     * zg_by_product_price
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title zg_by_product_price表的实体类
     * @description zg_by_product_price
     * @version 1.0
     * @author 18304
     * @date 2020-11-18 11:07:46
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
